ActiveReports 9
Reports with Parameterized Queries
Show AllShow All
Hide AllHide All

You can create dynamic queries to change the structure of a query at run time. This advanced walkthrough illustrates how to create a simple dynamic query.

The walkthrough is split into the following activities:

Note:
  • This walkthrough uses the MovieType table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located at [User Documents folder]\ComponentOne Samples\ActiveReports 9\Data\Reels.mdb.
  • Although this walkthrough uses Page reports, but this can be implemented using RDL reports also.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at runtime.

Design Time Layout

Runtime Layout

To add an ActiveReport to the Visual Studio project

To connect the report to a data source

To add a dataset

To create a layout for the report

To create a second dataset for use by the parameter list

To add parameters to the report

To modify the Products dataset to use a dynamic query

To add a header to display the chosen parameter label

To view the report

See Also

 

 


Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum